-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllProfilesUser`(IN p_userId BIGINT(20))
BEGIN

SELECT
`profId`,`parentProfId`,`firstName`,`lastName`,`gender`,`isDeath`
FROM `profiles`
WHERE `userId` = p_userId;

END
